﻿
CREATE procedure [dbo].[FC_Clientes_Search] 
@IdEntityF int
as

begin
	select 0 as IdCustomer, '' as Codigo, '' as Name, @IdEntityF as IdEntityF
	UNION ALL
	
	select IdCustomer, Codigo, ltrim(rtrim(Name)) + ' - ' + Codigo as 'Name', IdEntityF from dbo.FC_Customer
	where IdEntityF = @IdEntityF
	order by Name 
-----------
end

